package com.gxa.dao;

import com.gxa.common.JsonResult;
import com.gxa.pojo.CareRemind;
import com.gxa.pojo.Customer;

import java.sql.SQLException;
import java.util.List;

/*客户管理*/
public interface CustomerDao {
    /*查询客户集*/
    List queryCustomer() throws SQLException;
    /*查询客户集*/
    List queryCustomer(Integer currentPage, Integer pageSize) throws SQLException;

    List queryOrder(String customer_name) throws SQLException;
    /*计算客户总数*/
    Integer countCustomer() throws SQLException;

    /**
     * 客户满意度管理：按照客户名查询客户满意度
     * @param currentPage
     * @param pageSize
     * @param customer_name
     * @return
     * @throws SQLException
     */
    List searchCustomer(Integer currentPage, Integer pageSize, String customer_name) throws SQLException;

    List searchCustomer(Integer currentPage, Integer pageSize, String customer_name, Long mobile_phone) throws SQLException;

    Integer insertCustomer(Customer customer) throws SQLException;

    Integer deleteCustomer(Integer id) throws SQLException;

    Integer updateCustomer(Customer customer) throws SQLException;

    List queryCustomerSatisfaction(Integer currentPage, Integer pageSize) throws SQLException;

    Integer addCustomerSatisfaction(Customer customer) throws SQLException;

    Integer updateCustomerSatisfaction(Customer customer) throws SQLException;

    List queryCustomerCareRemind(Long customer_code, Integer currentPage, Integer pageSize) throws SQLException;

    Integer addCustomerCareRemind(CareRemind careRemind) throws SQLException;

    Integer updateCustomerCareRemind(CareRemind careRemind) throws SQLException;

    Integer deleteCustomerCareRemind(Integer id) throws SQLException;

    List searchCustomerCareRemind(Integer currentPage, Integer pageSize, String customer_name) throws SQLException;
}
